UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vCBmTma9wDA60C8pUt6J+mP33q/lelnKxnqjvOX09iw='
WHERE
key_id = 'd459877bfe948d3c1c53c4c4636d63d40e609d64e5fad1bed00321a994e15792'
AND (
token = 'vCBmTma9wDA60C8pUt6J+mP33q/lelnKxnqjvOX09iw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)