UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q8gtrBXDA8qylv2tCxltZN7D/CGASu8JJvOFdaiarfc='
WHERE
key_id = '7e48d5fc70988b8536e8f330ec1b6f3a83a68c9bc70eec8aabdefb33cb49485e'
AND (
token = 'q8gtrBXDA8qylv2tCxltZN7D/CGASu8JJvOFdaiarfc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)