UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aFe/t0YmLhlSgfVvm+lgyu1WLOxITt9tKXGI61XV1VQ='
WHERE
key_id = 'a47719277c40e880b54dd4e1b6f41c5cf71f95a84047939b0f7234a0993f432b'
AND (
token = 'aFe/t0YmLhlSgfVvm+lgyu1WLOxITt9tKXGI61XV1VQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)