UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/oe0ElNlUEn+eK/0djh5USIPoNwNjy8DEtGmtyswB9M='
WHERE
key_id = '4d8e0b2ba8251d2fc472ef5ee2e15f9d6540b3e927b9494fefc70fb5828b9714'
AND (
token = '/oe0ElNlUEn+eK/0djh5USIPoNwNjy8DEtGmtyswB9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)