UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gchnqgcq2ezJc30J96h2R/DNS9XmrQL78FPWSlnAJhY='
WHERE
key_id = 'b9d4412ce9867ea6c4d4afc7d1871ae6070d9c5cc74812966ca4613fcac92280'
AND (
token = 'gchnqgcq2ezJc30J96h2R/DNS9XmrQL78FPWSlnAJhY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)