UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'piAfKLWB+Iv2ZiZO9OsxSiU//eYl5Nioxcp0qy9vWwU='
WHERE
key_id = '3256c63c296e97c49741f963ea8fda0e532e5125804c0fcbcb505053371467c2'
AND (
token = 'piAfKLWB+Iv2ZiZO9OsxSiU//eYl5Nioxcp0qy9vWwU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)