UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HdzLwYuNoKAlcnZi+mq6NIYmaAnrqtxt3soF/G3IR6c='
WHERE
key_id = '02cc226c588d3ca945c6b654f687bec86fabe3f1e4c330d0a65255d9233964a8'
AND (
token = 'HdzLwYuNoKAlcnZi+mq6NIYmaAnrqtxt3soF/G3IR6c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)