UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/FB6eg0xov8vhrGWiwhICKxWn/XWvv2Rla69V9katH4='
WHERE
key_id = '4b7611a039b5bcd7300c941b89b2c88d55eec6e7336f62273bbfce7981585d9e'
AND (
token = '/FB6eg0xov8vhrGWiwhICKxWn/XWvv2Rla69V9katH4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)