UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KiSWfmWGtqlhok9qNMwnRgSaz/jj7Or9A0hg0QACC40='
WHERE
key_id = '834b5b0c6656de6b2cd2bf56f234508dcc1d2847e4efc080f3726bc4cef031d0'
AND (
token = 'KiSWfmWGtqlhok9qNMwnRgSaz/jj7Or9A0hg0QACC40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)