UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WM7RrZImFtGMBOXZi+X6jNbmBxRsU2SDWWYiU14AYyQ='
WHERE
key_id = '8f04d570073d20c8bfa7eb7c0b7a06a313eb3e73b0b66994c46aafa3f8a21103'
AND (
token = 'WM7RrZImFtGMBOXZi+X6jNbmBxRsU2SDWWYiU14AYyQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)