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