UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R5rPjmzKyS/1VRoGN2cYz5Sp5rgNznjBH3njdfiHfvA='
WHERE
key_id = 'cd0b6de6ef58929192f5a4eec381f6fca8f4d0aae299ddf99bfacd1f15c2d550'
AND (
token = 'R5rPjmzKyS/1VRoGN2cYz5Sp5rgNznjBH3njdfiHfvA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)