UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BMngIVRreayusz8h5h4bpR4dgk2iLeUvvGG7iog4WOE='
WHERE
key_id = '3e8a1c4b1108ed2c6a0e9d64c6a0f5a890a933c93d6638e391d30acce1499c0f'
AND (
token = 'BMngIVRreayusz8h5h4bpR4dgk2iLeUvvGG7iog4WOE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)