UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OTwM61zYW3UiQT2ND0/ZSu23v/ANkobVbcY313WTgg4='
WHERE
key_id = 'ea0c1cfebe364c978c5376f1b22a665e1d84d5653f09379df21b3736ad8f6cd9'
AND (
token = 'OTwM61zYW3UiQT2ND0/ZSu23v/ANkobVbcY313WTgg4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)