UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SH2QVEOqjKPpJRnQLiZntrT27O0+w72ZpltfdSTX308='
WHERE
key_id = 'd0e9c5e7df2133915e1ed6127198cf18a0c2ccbcb63b553f2a514c6698594057'
AND (
token = 'SH2QVEOqjKPpJRnQLiZntrT27O0+w72ZpltfdSTX308='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)