UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zIZfMSs8dpkDYdDB+BVzOPZWKzAehW7HOcAlmvgyxYA='
WHERE
key_id = '0e25df260f6f2c19e9e065b5a201856e22f81257d9dd6401b1db57f6d0466fe9'
AND (
token = 'zIZfMSs8dpkDYdDB+BVzOPZWKzAehW7HOcAlmvgyxYA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)