UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G9ykVXRgM6I3ifSgz4D/xGAUnDUhU6vRQaWeryvUIzg='
WHERE
key_id = '162f442fc4d8d7524f5d42d86c6964cdc241b4de2fe579ec0aa50f88dd73eee7'
AND (
token = 'G9ykVXRgM6I3ifSgz4D/xGAUnDUhU6vRQaWeryvUIzg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)