UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jXFFtgvQwqevAdp9oggngCW8SiFD4sN+T60VY5Lg3Z0='
WHERE
key_id = 'ac488f3104056bc8ae06ffca9068fe7378cc3c4a51adce6b7591d2b935a07dfd'
AND (
token = 'jXFFtgvQwqevAdp9oggngCW8SiFD4sN+T60VY5Lg3Z0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)