UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ypY4sYUgqvLs71/qtRtBIbMAFBcVumgiuIOuS2T4Jks='
WHERE
key_id = 'c519aee27098700c61658bb6d9af80a7db8ba46f2f29434fc4db9a504734c33a'
AND (
token = 'ypY4sYUgqvLs71/qtRtBIbMAFBcVumgiuIOuS2T4Jks='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)