UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nNV73ec4XKUPoFWi5dWvdJf14mvZ+sAgK+oOMpwlPJU='
WHERE
key_id = '2277789cb04ead17d66bc390a04ee34b5c8641b0d9aa8f702171e6b13fb53d3b'
AND (
token = 'nNV73ec4XKUPoFWi5dWvdJf14mvZ+sAgK+oOMpwlPJU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)