UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sWhXrWY53t13xvgNK1yyw14OyaX0GinU4X+pHzYFd1Q='
WHERE
key_id = '3bc4c5b443158819171eb849d9d1f92a221791b37f966725c82241c4571eddb8'
AND (
token = 'sWhXrWY53t13xvgNK1yyw14OyaX0GinU4X+pHzYFd1Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)