UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pVaBZDZorNBaS0ieLq/N0jzJG+jYF+uS+VNkIJ5tTKI='
WHERE
key_id = '3c10629fbcf89ab5df83081f889826effbb0819c5c4f2e2b5fd48a062e77ca20'
AND (
token = 'pVaBZDZorNBaS0ieLq/N0jzJG+jYF+uS+VNkIJ5tTKI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)