UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8dmt7Zr5abc+vtNPiUmxbJls73UKKG5gNdeiQJw86cY='
WHERE
key_id = '821c3567d845f244adc3e35b14ca7898b69f3a50e11c0dd55c20764d35cc4b54'
AND (
token = '8dmt7Zr5abc+vtNPiUmxbJls73UKKG5gNdeiQJw86cY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)