UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J4XU9aoUAtNH95FNDB+mTym32eZb1BZ+4/6KDnjQkUY='
WHERE
key_id = 'ca9c40455509f8e0043f627e9d7dfca3feb53d40721050d8e1bd88a1f8cb2e9b'
AND (
token = 'J4XU9aoUAtNH95FNDB+mTym32eZb1BZ+4/6KDnjQkUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)