UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AcU7htvxcqU5UQgw7D4TzG/ken3UFU7THWG2gsrp+xk='
WHERE
key_id = '138b625e402f6efbd7dbf233c54704239cd18082f6832ac1ba07f145ea7229b0'
AND (
token = 'AcU7htvxcqU5UQgw7D4TzG/ken3UFU7THWG2gsrp+xk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)