UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A63sCaIczepcW6A9vRqeH2R7AMPZBAL9Pt6A0tfTVzI='
WHERE
key_id = '8d12ddb2e180baa5daef4a76ff772092d30f39053f2b105c0aea0e4e2242f380'
AND (
token = 'A63sCaIczepcW6A9vRqeH2R7AMPZBAL9Pt6A0tfTVzI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)