UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BgCW1iMj2d24MY/7PhQC14qxoG4sUd+rzDgWIUnd9WA='
WHERE
key_id = '2d12011913e2b166d40c6eb1771c3c54e2da834c123d02067b306eb1a2138425'
AND (
token = 'BgCW1iMj2d24MY/7PhQC14qxoG4sUd+rzDgWIUnd9WA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)