UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NPkMlrXxXr99QCtlB6KuW8aWmN0EMhAsF/jSZODtwxM='
WHERE
key_id = 'ad29d825025299340d2886e805c71d057010d24c89721b782104b9aecdce2a5b'
AND (
token = 'NPkMlrXxXr99QCtlB6KuW8aWmN0EMhAsF/jSZODtwxM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)