UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4l6YzSnIraf2hhrzDU1pS9hH2JXn6b0rRkpX4loXZiY='
WHERE
key_id = 'ae5fbf7a7f3817a9a443f56ff47a00680dc4c46e21c5be8f0a8c3f81e8685a31'
AND (
token = '4l6YzSnIraf2hhrzDU1pS9hH2JXn6b0rRkpX4loXZiY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)