UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rXyHLHiLTgQlDyrBAN5xdQx0ZTO9v2S14k67SzXNfh0='
WHERE
key_id = '308ea0a4cb04271e8a1dc76babc3a4fa27e6a7b167b49770175ce9f3211e5a3d'
AND (
token = 'rXyHLHiLTgQlDyrBAN5xdQx0ZTO9v2S14k67SzXNfh0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)