UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NG1inhfVisxlrksIkmKp/H9hrj59/tD4oViAFmIPREU='
WHERE
key_id = '470cf08319af2c755c69ba7c382e41a07da15b42c924d1fb6a4218529d9e43d6'
AND (
token = 'NG1inhfVisxlrksIkmKp/H9hrj59/tD4oViAFmIPREU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)