UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XZOKoCN6uarCgLDX2QmjTnyhTa23NKHfk/GI1moYSnU='
WHERE
key_id = 'c06b70a55b2e549babfcb2a26f121a3b6091f130e81d768b564c5cfe5d653191'
AND (
token = 'XZOKoCN6uarCgLDX2QmjTnyhTa23NKHfk/GI1moYSnU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)