UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B4gPEoJHQMAbrXkXkvp2v8JHNLmD+THZpAD/a2B4RhA='
WHERE
key_id = 'c51bfabfd06d32eb37426c162eeed20b348d2be4a71b47d5438a96671480d36b'
AND (
token = 'B4gPEoJHQMAbrXkXkvp2v8JHNLmD+THZpAD/a2B4RhA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)