UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MXsdUEE8mBzwOEAiN4q4ErGvP3b61llBiEexRcLAoio='
WHERE
key_id = '47e722b1824cef9c4c0f964d7e3fd4220714c47b4d900e2bafdee9b253989778'
AND (
token = 'MXsdUEE8mBzwOEAiN4q4ErGvP3b61llBiEexRcLAoio='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)